In any of the reports, you can build filter expressions. They control which rows are displayed on the given report by applying logical conditions. These conditions are built using a block editor or a custom expression editor.
Each condition follows the format:
Field <Condition> Value
As shown in the formula, there are three key components of an expression
Field: A property of the row (e.g., Activity Area, Resource, Pit, Nominal Rate).
Condition: A logical operator (e.g., Equals, Starts with, Does not contain, Is blank).
Value: The specific value to compare against the attribute (e.g., 992-1, North Pit, Drill).
You can organise conditions into groups to build more complex logic. Each group can contain multiple rows, where each row represents a single condition. The logical operator of a group determines how its conditions are evaluated.
And: All conditions in the groups must return True.
Or: At least one condition in the group must return True.
Not And: The group is True if not all conditions are True.
Not Or: The group is True if none of the conditions are True.
Groups can be nested within other groups to create layered logic.
For example, an And group could contain these conditions:
Resource starts with 992
Activity Area equals Mining
Only rows that match all conditions will be shown.
When adding a condition, you have the option to create a custom expression to write a custom expression manually. The editor gives you access to all available attributes and other fields, functions, and equations. When saving the expression, the software converts its conditions to a block format.
The above conditions would be expressed like this:
StartsWith([Resource], '992') AND [Activity] = 'Mining'